UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Y+bRmmZzKCYVHrOlF/eralOowugEYGAOHYpfIhu4bdA='
WHERE
key_id = 'b8a21e58f828a357ceeb1f22bfd94062514c6c0aefe68d6bbe9d4ed9c54a70d8'
AND (
token = 'Y+bRmmZzKCYVHrOlF/eralOowugEYGAOHYpfIhu4bdA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)