UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lfXMYtXEj1aM3k0TffUxy5v5csseB0PkPLBoT/3rw5c='
WHERE
key_id = '8d3bc6fa530f0c52d63136d7ba37550ad6291f3f114897aa8305bf49caa6bc6b'
AND (
token = 'lfXMYtXEj1aM3k0TffUxy5v5csseB0PkPLBoT/3rw5c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)