UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'U4wyOk+DJL6fKciv7GID8mSfNanXLhC0kr5cI7+tasw='
WHERE
key_id = 'ac81a7b0a4d1265e65b3905720a5173d37e0e41219ac4641f29824d077f244a5'
AND (
token = 'U4wyOk+DJL6fKciv7GID8mSfNanXLhC0kr5cI7+tasw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)