UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7iBcu9iIMqpRahL6Hh0Lf4/LQHqIFdEynC/I5TBG2C0='
WHERE
key_id = 'abae37e314aa4620ad13c15a055c3df639eda967ef906c1ac84c361e1e6d413f'
AND (
token = '7iBcu9iIMqpRahL6Hh0Lf4/LQHqIFdEynC/I5TBG2C0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)