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