UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YQG8JjwnJAh2oi2FTzpxMsajB1866aMaa9bsgm1U3j4='
WHERE
key_id = '2d27ff28a07f2fe41bdb18953ac8b7fb1237e22b6f1425d1aecad25a7f4e422a'
AND (
token = 'YQG8JjwnJAh2oi2FTzpxMsajB1866aMaa9bsgm1U3j4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)