UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1D929mdNVK2IMPpDjLkRW+smG3J4c+W/lio7p5pt48M='
WHERE
key_id = '6e03b64013d61134bdd028babc755c8a5e9a5a845fe7e93608f534aa115941e4'
AND (
token = '1D929mdNVK2IMPpDjLkRW+smG3J4c+W/lio7p5pt48M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)