UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qD7gG7i7JFh+BI3Z8XiDm3/YPPpsqFz06Z1KXN1sUbg='
WHERE
key_id = 'dc51fc459d970403e2ca1e7e757a63ef545ceb4b3a956231a466787459622795'
AND (
token = 'qD7gG7i7JFh+BI3Z8XiDm3/YPPpsqFz06Z1KXN1sUbg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)