UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rn3pYwB5B2RaMrVyrJVApXXEmXEq0ra3mEpFIsiPwX0='
WHERE
key_id = '989f992d72c3ae3bf8438e101eccc1e7727c344c9ad96659557a7532e49b9486'
AND (
token = 'rn3pYwB5B2RaMrVyrJVApXXEmXEq0ra3mEpFIsiPwX0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)