UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HO58cnRqRAqMNNUIadOacZQCMqru11L4kerIe+cPsF4='
WHERE
key_id = 'abacdbd9e9353d4eca184b21a79122d7d3f522d5ff2c427dbe1187f5b67b847c'
AND (
token = 'HO58cnRqRAqMNNUIadOacZQCMqru11L4kerIe+cPsF4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)