UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1KBJlg5UsldiMHMY3x3C8kqZDPBF4NZs0HhOVVPw4gs='
WHERE
key_id = 'c8d136d7ad9fde5358e4351635becbb4082291a2d743e92e0aed88d0918a81e9'
AND (
token = '1KBJlg5UsldiMHMY3x3C8kqZDPBF4NZs0HhOVVPw4gs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)