UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'htiyMDbpXHEbyccZbyOqCqVaXWpIfGnjBTmivn9ICjk='
WHERE
key_id = 'a6ed21c29fd0026bec6aba1a885ef2ae04acb911c06a1115a2b1e3e97babe404'
AND (
token = 'htiyMDbpXHEbyccZbyOqCqVaXWpIfGnjBTmivn9ICjk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)