UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sBcDSC2qmHh4HPmVUV56gzkDI+098Jk2By8yvFFMrRE='
WHERE
key_id = '46efb1f9f3cec8117cd2e3e4e10786ec521dda34b0f7e4223f44c506d7f684cd'
AND (
token = 'sBcDSC2qmHh4HPmVUV56gzkDI+098Jk2By8yvFFMrRE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)