UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NqljSD+YknwTeGIFe5x9DecXwFAdQC1fRSjWSla6nYA='
WHERE
key_id = 'c71feea22fbb7f1570e8915cf94645d6fc1f4874b05c7828172de68473b0ea0d'
AND (
token = 'NqljSD+YknwTeGIFe5x9DecXwFAdQC1fRSjWSla6nYA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)