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