UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cpB+HCaStqA+nlZYm/ORQRGDJkJJl+s5JNJ1wdAPIPo='
WHERE
key_id = 'cfc416e31e856a86fba7e690d333a67e92bb42b5a6d62a62efca040a8777085a'
AND (
token = 'cpB+HCaStqA+nlZYm/ORQRGDJkJJl+s5JNJ1wdAPIPo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)