UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RouT5gkrOb2Jj5+lCHhTeac9IcsxXC+rOb+I36Roum8='
WHERE
key_id = '530287c5248940fdeb8d18747cd43557fcabb1cb038f8cec8c2d6d94947e12d5'
AND (
token = 'RouT5gkrOb2Jj5+lCHhTeac9IcsxXC+rOb+I36Roum8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)