UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BtFD24dTyLlUQfdgnc5OXohNl05okPiBHqqFh/IzHEw='
WHERE
key_id = 'dfceb524cdc17ade587967c9e5863ede3ba469da010c48d89b377bcc10579ada'
AND (
token = 'BtFD24dTyLlUQfdgnc5OXohNl05okPiBHqqFh/IzHEw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)