UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LQQ46DpurFL9Ix88OTWJ2Zd6sjbggfEM8MSf0Ic5qvs='
WHERE
key_id = '7b8f3d3597f5ff74d4978abf5915fd8efd75ca88aafda442d7bff225b851c78e'
AND (
token = 'LQQ46DpurFL9Ix88OTWJ2Zd6sjbggfEM8MSf0Ic5qvs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)