UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'acVPocULfW30XvqK5Rdq64pMpt7Gojlyzz6gamW5oCY='
WHERE
key_id = '22b9b6c6de3fece01f8fb471ef9518df7968c11b6a6c110acdc12efb1f6780c1'
AND (
token = 'acVPocULfW30XvqK5Rdq64pMpt7Gojlyzz6gamW5oCY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)