UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cblRvOeM3j4W3cJP7fofqF76gkFkEpaUX8ZtUmVBSGM='
WHERE
key_id = 'c3ad9617dc2463a563bcc020fd82d32a5047ea012c1c593f1309743ed98d531c'
AND (
token = 'cblRvOeM3j4W3cJP7fofqF76gkFkEpaUX8ZtUmVBSGM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)