UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Ljzw1gD+86Bf0s4D5ApRWBWy/Dtm0Uss8mA3HSHJEMc='
WHERE
key_id = '530762871462a3d124086d007a38a59995bcda446a8dbca442874b67f3963e00'
AND (
token = 'Ljzw1gD+86Bf0s4D5ApRWBWy/Dtm0Uss8mA3HSHJEMc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)