UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZL6toRkwYiW0GQNcA7QvbNFIUfWEg/hKv9gbyNEtE0M='
WHERE
key_id = '159b0afdad9b1ad8b5b4f29f1246b2f2fa180b02832e8b6c17d9b88a16c4f55b'
AND (
token = 'ZL6toRkwYiW0GQNcA7QvbNFIUfWEg/hKv9gbyNEtE0M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)