UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'd2rBFZLIGpnCU0t6scax1RCgvR+6TvcQ2y0U4UedOms='
WHERE
key_id = '9f514e7e845a454799b8e739ad9677a931e48927fa6cd7c2c81c3b37d43fba35'
AND (
token = 'd2rBFZLIGpnCU0t6scax1RCgvR+6TvcQ2y0U4UedOms='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)