UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'U3eD8aAMo32zGpq0smw75OMS0Mz6gk8UjhgfXepXLmU='
WHERE
key_id = 'c6468486bd0492c4891dcfcfdab501afdf3649d9e277a40ff607ffe2e4c8e6e3'
AND (
token = 'U3eD8aAMo32zGpq0smw75OMS0Mz6gk8UjhgfXepXLmU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)