UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6b2SilKabDUQGr8lXvMes2sXqDTNCpaawwksUa0y+Xk='
WHERE
key_id = '712caae950e85d563643fa13f71c8ef2464ba9859182343358fc17f13a16e228'
AND (
token = '6b2SilKabDUQGr8lXvMes2sXqDTNCpaawwksUa0y+Xk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)