UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RoDpfopLpysOn6vOIWuVcR5gwD122k3LqVzIL6aOvb8='
WHERE
key_id = '58fa5477df6fdca8bcea91765c339a3944f334aaa2fdbeba99955409ba54b10d'
AND (
token = 'RoDpfopLpysOn6vOIWuVcR5gwD122k3LqVzIL6aOvb8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)