UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fYBSie6VuG7Plglm3Sk8YlRNdDU2qjca5f3U5iTjLWs='
WHERE
key_id = '54de0936c601cc3aac2df6f05129e22ea947bb687e2f4cb60df66f5653e4e26c'
AND (
token = 'fYBSie6VuG7Plglm3Sk8YlRNdDU2qjca5f3U5iTjLWs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)