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