UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p6iCLy+Bjkg4B9dMk4dwv2Jba2K6SwVfq6Vr8zyGg4I='
WHERE
key_id = 'a195df5307cc0b72875af5130755203fb7339dfb4d661d9ccad895bf076145ca'
AND (
token = 'p6iCLy+Bjkg4B9dMk4dwv2Jba2K6SwVfq6Vr8zyGg4I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)