UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'H03XcdnaUVbAJlsdmF8AJw4LsiZzgGbj93CkOdYlUZ4='
WHERE
key_id = '771184fb2449d5240f725e6f7e03902e2761766ede672dd92366c9478cb6a4cc'
AND (
token = 'H03XcdnaUVbAJlsdmF8AJw4LsiZzgGbj93CkOdYlUZ4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)