UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rfgBSVRG+c/B2DVKFUqq9xpyldGR7l9/G8P1jvr9stw='
WHERE
key_id = 'd8aa9ac453480be68b7de15fecb4fb8140cbe50fec8a3c7b4ee8d41cc07cc85a'
AND (
token = 'rfgBSVRG+c/B2DVKFUqq9xpyldGR7l9/G8P1jvr9stw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)