UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qNTPbM2SksmtSzIB9JJoVsNeAxo+PFFWyEOATFrmmlc='
WHERE
key_id = '4bc7b960577df6724aed56901e39c131285c35ddca473190b07a27a6a2642269'
AND (
token = 'qNTPbM2SksmtSzIB9JJoVsNeAxo+PFFWyEOATFrmmlc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)