UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7R6ZJoKThO3G7ztBFCavsAZx3AbIrXhlyYgbPgiZ84U='
WHERE
key_id = 'b11b8ca5b62af9df96e7e96a9a19fbbc4c361ea8c25f362cb5a37c241d4fae68'
AND (
token = '7R6ZJoKThO3G7ztBFCavsAZx3AbIrXhlyYgbPgiZ84U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)