UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jYgHp58S8lq+OYNyFF5yqj7oPBOXzKebnJ63x48Xyuo='
WHERE
key_id = 'ce0d7d5a6e26f8c841e6659a249e302358696becfbfcb923d61cce58f1a3e894'
AND (
token = 'jYgHp58S8lq+OYNyFF5yqj7oPBOXzKebnJ63x48Xyuo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)