UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0pcnjSsZ0G7XYLiv2gl6Iz0CiowYcRQFoBGRi6fJIPc='
WHERE
key_id = '8a6a854544994613b07ed9ba207f6f98b136a63c77f4a0d0edc6f512ebd485ef'
AND (
token = '0pcnjSsZ0G7XYLiv2gl6Iz0CiowYcRQFoBGRi6fJIPc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)