UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3dGzVFQZq/CQA20jWCkgH18dJPDOG2O+wk1cijzN6gs='
WHERE
key_id = 'a6197bd7be5e0da9e6e0da347273238d42eae3011c750f17d1de822e9ea1d719'
AND (
token = '3dGzVFQZq/CQA20jWCkgH18dJPDOG2O+wk1cijzN6gs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)