UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8Kaw8he6rd04YOwJRXxm3xlKNd1pBLJVGCtJsrhhNA0='
WHERE
key_id = '029956070dd9859313b78c76ff92a75abb8a55c46a0dc096a59ac63c0994eb46'
AND (
token = '8Kaw8he6rd04YOwJRXxm3xlKNd1pBLJVGCtJsrhhNA0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)