UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9WzyphB7bhCabN4YwaT6xqq3IJbj7E1ep+ilz6rFnWI='
WHERE
key_id = '3adf9973adb6937e5613406f230a07cb29567b5eed0444242dabea0abc198fcd'
AND (
token = '9WzyphB7bhCabN4YwaT6xqq3IJbj7E1ep+ilz6rFnWI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)