UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oP0U7LPqxA2vRmvvGDXUcEvEqX7oa61faK1TsxBtCbI='
WHERE
key_id = '10c18e96ba5fe87d075f45a7c0d65be7a8ecc52ef6b16bd9ca1057efa1944f5b'
AND (
token = 'oP0U7LPqxA2vRmvvGDXUcEvEqX7oa61faK1TsxBtCbI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)