UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'S7kKQQ7DREL694RGewvI2XEpvt28D/HkNgmFgtm1o+M='
WHERE
key_id = 'e99db53818ec3ad701a11ca8ba0c6f04ac4719d368aa283499f5e11517b8e578'
AND (
token = 'S7kKQQ7DREL694RGewvI2XEpvt28D/HkNgmFgtm1o+M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)