UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3s6fUaawVyjAKQzhfjwhnkaV5Y3IdmXczD2sMVO4kD4='
WHERE
key_id = '4733f1e28e30c12bcc52cab7da79cf9adbc3399c8e8e38794ad1fe37053ba3d2'
AND (
token = '3s6fUaawVyjAKQzhfjwhnkaV5Y3IdmXczD2sMVO4kD4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)