UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7q2tMCa+S3UqRPsrTOn7+Q6rkPyXbQTDNEvggTVwDUk='
WHERE
key_id = '980fe6167e969f1edc4c38b68b1c32c66f91f74fda9e267cc263b502218757a8'
AND (
token = '7q2tMCa+S3UqRPsrTOn7+Q6rkPyXbQTDNEvggTVwDUk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)