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