UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zgfmJedCFSy0YC8U7k1k1sLddkyuSRQuDk+iT9uT8Xo='
WHERE
key_id = '8bc4d9b081cf3fa970903c56ce774280083ca94cd8f6ead6380e9924c793a13b'
AND (
token = 'zgfmJedCFSy0YC8U7k1k1sLddkyuSRQuDk+iT9uT8Xo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)