UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Z/Cybg/hvM8Ll3PDHc1BQYUAYrzEQCMqdLOXJbm+I0I='
WHERE
key_id = 'c7007d18e7c7ab3007d9367a257eccdb0e60298b36f05fa5489825517ec41a56'
AND (
token = 'Z/Cybg/hvM8Ll3PDHc1BQYUAYrzEQCMqdLOXJbm+I0I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)