UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZnB6UV54sfAKtie5t8AwqXvU/PFLcK22NGmtYSej0bQ='
WHERE
key_id = 'e4b48509dfab09f15e4f83cb2257103d1bedc3c2ab2b113c9a18eb985e196fb9'
AND (
token = 'ZnB6UV54sfAKtie5t8AwqXvU/PFLcK22NGmtYSej0bQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)