UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DPD3ajRwT1g7I/qAAyjTvodI96TNVAqZ3DeiaHj3mss='
WHERE
key_id = '8f709d8afadabc7f8846ac164d54878fd0150048093d9e9dbd704f7bcc2707ed'
AND (
token = 'DPD3ajRwT1g7I/qAAyjTvodI96TNVAqZ3DeiaHj3mss='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)