UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PA79w2c26WzfkfpVibjTyQIaAwB2+s9EzP9rKuoWpyI='
WHERE
key_id = '47bce6b6a1233967296a2a0bee2f8504ec40a4f90743cc40fa5b4e0c8167dd03'
AND (
token = 'PA79w2c26WzfkfpVibjTyQIaAwB2+s9EzP9rKuoWpyI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)