UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8gK7/mMGv0axUSJtAvz9xNa5oxVXeXGVFj5pDOuNNPo='
WHERE
key_id = '24806b201856dcfd8cd57662221752fd1becbbf4b4b97139c28c9c18962cb62e'
AND (
token = '8gK7/mMGv0axUSJtAvz9xNa5oxVXeXGVFj5pDOuNNPo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)